package com.ruoyi.huanghefd.mapper;
import org.apache.ibatis.annotations.Param;

import com.ruoyi.huanghefd.domain.LimitWorkApproveSheet;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
* @author gnplum
* @description 针对表【limit_work_approve_sheet(有限空间作业审批单)】的数据库操作Mapper
* @createDate 2024-12-03 17:42:16
* @Entity com.ruoyi.huanghefd.domain.LimitWorkApproveSheet
*/
@Mapper
public interface LimitWorkApproveSheetMapper extends BaseMapper<LimitWorkApproveSheet> {
    /**
     * @param limitWorkApproveSheet
     * @return int
     * @Author gnplum
     * @Description //新增 有限空间作业审批单
     * @Date 10:28 2024/12/04
     **/
    int insertAll(LimitWorkApproveSheet limitWorkApproveSheet);
    /**
     * @param lsCode
     * @return int
     * @Author gnplum
     * @Description //删除 有限空间作业审批单
     * @Date 10:28 2024/12/04
     **/
    int delByLsCode(@Param("lsCode") String lsCode);
    /**
     * @param limitWorkApproveSheet
     * @return int
     * @Author gnplum
     * @Description //修改 有限空间作业审批单
     * @Date 10:28 2024/12/04
     **/
    int updateByLsId(LimitWorkApproveSheet limitWorkApproveSheet);
    /**
     * @param lsCode,lsDept,lsState,userId,mailType,startIndex,pageSize
     * @return int
     * @Author gnplum
     * @Description //分页查询 有限空间作业审批单
     * @Date 10:28 2024/12/04
     **/
    List<LimitWorkApproveSheet> queryLimitWorkApproveSheetByPage(@Param("lsCode") String lsCode, @Param("lsDept") String lsDept, @Param("lsState") String lsState, @Param("userId") String userId, @Param("mailType") String mailType,@Param("startIndex") int startIndex, @Param("pageSize") int pageSize);
    /**
     * @return int
     * @Author gnplum
     * @Description //查询  有限空间作业审批单数量  分页总数
     * @Date 2:02 2023/12/20
     **/
    int getLimitWorkApproveSheetNum(@Param("lsCode") String lsCode, @Param("lsDept") String lsDept, @Param("lsState") String lsState, @Param("userId") String userId, @Param("mailType") String mailType);
    /**
     * @return int
     * @Author gnplum
     * @Description //获取  审批单编号
     * @Date 16:34 2024/12/4
     **/
    int getLsCodeNum(@Param("PJLX") String PJLX);
    /**
     * @param userId
     * @return int
     * @Author gnplum
     * @Description //获取正在执行票数量
     * @Date 23:50 2024/12/4
     **/
    int getExeSheetNum( @Param("userId") String userId);
}




